
insert into d280db1.dbo.t280loc
select distinct f_loc_c	
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280div
select distinct f_div_c	
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280dpt
select distinct f_dpt_c	
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280afm
select distinct f_afm_c	
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280stg
select distinct f_stg_c	
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280fop
select distinct substring(f_fop_c,1,3)+"xxx"	
  from d280db1.dbo.t280sum                                                    
 where f_fop_c like '01____'
union
select distinct f_fop_c	
  from d280db1.dbo.t280sum                                                    
 where f_fop_c > '019999'    
go   

insert into d280db1.dbo.t280src
select distinct f_syssrc_c
  from d280db1.dbo.t280sum                                                    
go   

insert into d280db1.dbo.t280fypd
select distinct f_fypd    
  from d280db1.dbo.t280sum                                                    
go   

